package com.zmj.sy.mom.srv.aps.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.zmj.sy.mom.srv.aps.bean.entity.lantekpre.LantekNestExcess;
import com.zmj.sy.mom.srv.aps.bean.vo.report.ReportPreExcessWeightVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface LantekNestExcessMapper extends SyMapper<LantekNestExcess> {

    @Select("SELECT e.texture AS texture, e.norm AS thickness, CONCAT(e.texture,'#',e.norm) AS norm, SUM(e.weight) AS weight FROM tb_third_lantek_nest_excess e ${ew.customSqlSegment} ")
    List<ReportPreExcessWeightVo> getPreExcessWeight(@Param(Constants.WRAPPER) QueryWrapper<LantekNestExcess> qwe);

}
